/*
 Navicat Premium Data Transfer

 Source Server         : zhou
 Source Server Type    : MySQL
 Source Server Version : 80027 (8.0.27)
 Source Host           : 8.130.118.110:3306
 Source Schema         : lcz_blog

 Target Server Type    : MySQL
 Target Server Version : 80027 (8.0.27)
 File Encoding         : 65001

 Date: 16/06/2023 10:26:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lcz_article
-- ----------------------------
DROP TABLE IF EXISTS `lcz_article`;
CREATE TABLE `lcz_article`
(
    `id`              int                                                          NOT NULL AUTO_INCREMENT,
    `author_id`       int                                                          NOT NULL COMMENT '作者id',
    `category_id`     int                                                            DEFAULT NULL COMMENT '文章分类id',
    `article_cover`   varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文章缩略图',
    `article_title`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
    `article_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
    `type`            tinyint(1) DEFAULT '1' COMMENT '文章类型 1原创 2转载 3翻译',
    `original_url`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '原文链接',
    `is_top`          tinyint(1) DEFAULT '0' COMMENT '是否置顶 0否 1是',
    `status`          tinyint(1) DEFAULT '1' COMMENT '状态值 1公开 2私密 3评论可见',
    `is_delete`       tinyint(1) DEFAULT '0' COMMENT '是否删除  0否 1是',
    `gmt_create`      datetime                                                       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`    datetime                                                       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY               `idx_category_id` (`category_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='文章';

-- ----------------------------
-- Records of lcz_article
-- ----------------------------
BEGIN;
INSERT INTO `lcz_article` (`id`, `author_id`, `category_id`, `article_cover`, `article_title`, `article_content`,
                           `type`, `original_url`, `is_top`, `status`, `is_delete`, `gmt_create`, `gmt_modified`)
VALUES (1, 1, 1, 'https://s2.loli.net/2023/06/16/CLvuKcQ7e9aV5Rz.png', '测试标题',
        '# 测试\n## 测试添加文章\n### 测试添加图片\n![奥地利阿尔卑斯山壁纸_彼岸壁纸.jpg](http://rw9u4bo2x.hn-bkt.clouddn.com/article/13db38a8-e60d-4e4b-ae82-417b76aa8f86.jpg)',
        1, NULL, 1, 1, 0, '2021-10-11 16:49:40', '2023-06-16 01:59:14');
COMMIT;

-- ----------------------------
-- Table structure for lcz_article_tag
-- ----------------------------
DROP TABLE IF EXISTS `lcz_article_tag`;
CREATE TABLE `lcz_article_tag`
(
    `id`           int NOT NULL AUTO_INCREMENT,
    `article_id`   int NOT NULL COMMENT '文章id',
    `tag_id`       int NOT NULL COMMENT '标签id',
    `gmt_create`   datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY            `idx_article_id` (`article_id`) USING BTREE,
    KEY            `idx_tag_id` (`tag_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='文章标签\n';

-- ----------------------------
-- Records of lcz_article_tag
-- ----------------------------
BEGIN;
INSERT INTO `lcz_article_tag` (`id`, `article_id`, `tag_id`, `gmt_create`, `gmt_modified`)
VALUES (5, 1, 1, '2023-06-15 15:21:06', '2023-06-15 15:21:06');
COMMIT;

-- ----------------------------
-- Table structure for lcz_category
-- ----------------------------
DROP TABLE IF EXISTS `lcz_category`;
CREATE TABLE `lcz_category`
(
    `id`            int                                                          NOT NULL AUTO_INCREMENT,
    `category_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名',
    `gmt_create`    datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`  datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='分类\n';

-- ----------------------------
-- Records of lcz_category
-- ----------------------------
BEGIN;
INSERT INTO `lcz_category` (`id`, `category_name`, `gmt_create`, `gmt_modified`)
VALUES (1, '测试分类', '2021-10-11 16:48:55', '2021-10-11 16:49:13');
COMMIT;

-- ----------------------------
-- Table structure for lcz_comment
-- ----------------------------
DROP TABLE IF EXISTS `lcz_comment`;
CREATE TABLE `lcz_comment`
(
    `id`              int NOT NULL AUTO_INCREMENT,
    `user_id`         int NOT NULL COMMENT '评论用户Id',
    `article_id`      int      DEFAULT NULL COMMENT '评论文章id',
    `comment_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论内容',
    `reply_id`        int      DEFAULT NULL COMMENT '回复用户id',
    `parent_id`       int      DEFAULT NULL COMMENT '父评论id',
    `is_audit`        tinyint(1) DEFAULT '1' COMMENT '是否审核',
    `gmt_create`      datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`    datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY               `idx_comment_user` (`user_id`) USING BTREE,
    KEY               `idx_comment_article` (`article_id`) USING BTREE,
    KEY               `idx_comment_parent` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='评论\n';

-- ----------------------------
-- Records of lcz_comment
-- ----------------------------
BEGIN;
INSERT INTO `lcz_comment` (`id`, `user_id`, `article_id`, `comment_content`, `reply_id`, `parent_id`, `is_audit`,
                           `gmt_create`, `gmt_modified`)
VALUES (1, 1, 1, '测试评论', NULL, NULL, 1, '2021-10-12 19:19:55', '2021-10-13 23:01:26');
COMMIT;

-- ----------------------------
-- Table structure for lcz_menu
-- ----------------------------
DROP TABLE IF EXISTS `lcz_menu`;
CREATE TABLE `lcz_menu`
(
    `id`           int                                                          NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`         varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名',
    `path`         varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单路径',
    `component`    varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '组件',
    `icon`         varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单icon',
    `gmt_create`   datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `order_num`    tinyint(1) NOT NULL COMMENT '排序',
    `parent_id`    int      DEFAULT NULL COMMENT '父id',
    `is_hidden`    tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否隐藏  0否1是',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='菜单\n';

-- ----------------------------
-- Records of lcz_menu
-- ----------------------------
BEGIN;
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (1, '首页', '/', '/home/Home.vue', 'el-icon-myshouye', '2021-10-16 17:25:30', '2021-10-16 17:25:30', 1, NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (2, '文章管理', '/article-submenu', 'layout', 'el-icon-mywenzhang-copy', '2021-10-16 17:25:30',
        '2021-10-16 17:27:02', 2, NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (3, '消息管理', '/message-submenu', 'layout', 'el-icon-myxiaoxi', '2021-10-16 17:25:30', '2021-10-16 17:27:01',
        3, NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (4, '系统管理', '/system-submenu', 'layout', 'el-icon-myshezhi', '2021-10-16 17:25:30', '2021-10-16 17:27:00', 5,
        NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (5, '个人中心', '/setting', '/setting/Setting.vue', 'el-icon-myuser', '2021-10-16 17:25:30',
        '2021-10-16 17:25:30', 7, NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (6, '发布文章', '/article', '/article/Article.vue', 'el-icon-myfabiaowenzhang', '2021-10-16 17:25:30',
        '2021-10-16 20:44:54', 1, 2, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (7, '修改文章', '/article/*', '/article/Article.vue', 'el-icon-myfabiaowenzhang', '2021-10-16 17:25:30',
        '2021-10-16 20:44:56', 2, 2, 1);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (8, '文章列表', '/article-list', '/article/ArticleList.vue', 'el-icon-mywenzhangliebiao', '2021-10-16 17:25:30',
        '2021-10-16 17:25:30', 3, 2, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (9, '分类管理', '/category', '/category/Category.vue', 'el-icon-myfenlei', '2021-10-16 17:25:30',
        '2021-10-16 20:44:59', 4, 2, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (10, '标签管理', '/tag', '/tag/Tag.vue', 'el-icon-myicontag', '2021-10-16 17:25:30', '2021-10-16 20:45:00', 5, 2,
        0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (11, '评论管理', '/comment', '/comment/Comment.vue', 'el-icon-mypinglunzu', '2021-10-16 17:25:30',
        '2021-10-16 20:45:01', 1, 3, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (12, '留言管理', '/message', '/message/Message.vue', 'el-icon-myliuyan', '2021-10-16 17:25:30',
        '2021-10-16 20:45:02', 2, 3, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (13, '用户列表', '/user', '/user/User.vue', 'el-icon-myyonghuliebiao', '2021-10-16 17:25:30',
        '2021-10-16 20:45:02', 1, 22, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (14, '角色管理', '/role', '/role/Role.vue', 'el-icon-myjiaoseliebiao', '2021-10-16 17:25:30',
        '2021-10-16 20:45:04', 2, 28, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (15, '接口管理', '/resource', '/resource/Resource.vue', 'el-icon-myjiekouguanli', '2021-10-16 17:25:30',
        '2021-10-16 20:45:05', 2, 28, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (16, '菜单管理', '/menu', '/menu/Menu.vue', 'el-icon-mycaidan', '2021-10-16 17:25:30', '2021-10-16 20:45:06', 2,
        28, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (18, '关于我', '/about', '/about/About.vue', 'el-icon-myguanyuwo', '2021-10-16 17:25:30', '2021-10-16 17:25:30',
        4, 4, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (19, '日志管理', '/log-submenu', 'layout', 'el-icon-myguanyuwo', '2021-10-16 17:25:30', '2021-10-16 17:26:59', 6,
        NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (20, '操作日志', '/operation/log', '/log/Operation.vue', 'el-icon-myguanyuwo', '2021-10-16 17:25:30',
        '2021-10-16 17:25:30', 1, 19, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (21, '在线用户', '/online/user', '/user/Online.vue', 'el-icon-myyonghuliebiao', '2021-10-16 17:25:30',
        '2021-10-16 20:45:11', 7, 22, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (22, '用户管理', '/user-submenu', 'layout', 'el-icon-myyonghuliebiao', '2021-10-16 17:25:30',
        '2021-10-16 20:45:20', 4, NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (26, '页面管理', '/page', '/page/Page.vue', 'el-icon-myyemianpeizhi', '2021-10-16 17:25:30',
        '2021-10-16 20:45:26', 2, 4, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (28, '权限管理', '/permission-submenu', 'layout', 'el-icon-mydaohanglantubiao_quanxianguanli',
        '2021-10-16 17:25:30', '2021-10-16 17:26:54', 4, NULL, 0);
INSERT INTO `lcz_menu` (`id`, `name`, `path`, `component`, `icon`, `gmt_create`, `gmt_modified`, `order_num`,
                        `parent_id`, `is_hidden`)
VALUES (29, '网站管理', '/website', '/website/Website.vue', 'el-icon-myxitong', '2021-10-16 17:25:30',
        '2021-10-16 17:25:30', 1, 4, 0);
COMMIT;

-- ----------------------------
-- Table structure for lcz_message
-- ----------------------------
DROP TABLE IF EXISTS `lcz_message`;
CREATE TABLE `lcz_message`
(
    `id`              int                                                           NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `nickname`        varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '昵称',
    `avatar`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像',
    `message_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '留言内容',
    `ip_addr`         varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '用户ip',
    `ip_source`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户地址',
    `time`            tinyint(1) DEFAULT NULL COMMENT '弹幕速度',
    `is_audit`        tinyint(1) DEFAULT '1' COMMENT '是否审核',
    `gmt_create`      datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`    datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='留言\n';

-- ----------------------------
-- Records of lcz_message
-- ----------------------------
BEGIN;
INSERT INTO `lcz_message` (`id`, `nickname`, `avatar`, `message_content`, `ip_addr`, `ip_source`, `time`, `is_audit`,
                           `gmt_create`, `gmt_modified`)
VALUES (1, '游客', 'https://s2.loli.net/2023/06/16/CLvuKcQ7e9aV5Rz.png', '测试添加留言', '127.0.0.1', '', 7, 1,
        '2021-10-14 14:21:14', '2023-06-16 02:19:45');
COMMIT;

-- ----------------------------
-- Table structure for lcz_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `lcz_operation_log`;
CREATE TABLE `lcz_operation_log`
(
    `id`             int                                                           NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `opt_module`     varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '操作模块',
    `opt_type`       varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '操作类型',
    `opt_url`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作url',
    `opt_method`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作方法',
    `opt_desc`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作描述',
    `request_param`  longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求参数',
    `request_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '请求方式',
    `response_data`  longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '返回数据',
    `user_id`        int                                                           NOT NULL COMMENT '用户id',
    `nickname`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '用户昵称',
    `ip_addr`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作ip',
    `ip_source`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作地址',
    `gmt_create`     datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`   datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='操作日志\n';

-- ----------------------------
-- Records of lcz_operation_log
-- ----------------------------
BEGIN;
INSERT INTO `lcz_operation_log` (`id`, `opt_module`, `opt_type`, `opt_url`, `opt_method`, `opt_desc`, `request_param`,
                                 `request_method`, `response_data`, `user_id`, `nickname`, `ip_addr`, `ip_source`,
                                 `gmt_create`, `gmt_modified`)
VALUES (13, '用户模块', '修改', '/admin/user/disable', 'com.lcz.controller.UserController.updateUserDisableStatus',
        '修改用户禁用状态', '[{\"id\":3,\"isDisable\":1}]', 'PUT',
        '{\"code\":200,\"message\":\"success\",\"status\":true}', 1, '管理员', '127.0.0.1', '', '2023-06-16 10:25:35',
        '2023-06-16 10:25:35');
INSERT INTO `lcz_operation_log` (`id`, `opt_module`, `opt_type`, `opt_url`, `opt_method`, `opt_desc`, `request_param`,
                                 `request_method`, `response_data`, `user_id`, `nickname`, `ip_addr`, `ip_source`,
                                 `gmt_create`, `gmt_modified`)
VALUES (14, '用户模块', '修改', '/admin/user/disable', 'com.lcz.controller.UserController.updateUserDisableStatus',
        '修改用户禁用状态', '[{\"id\":3,\"isDisable\":0}]', 'PUT',
        '{\"code\":200,\"message\":\"success\",\"status\":true}', 1, '管理员', '127.0.0.1', '', '2023-06-16 10:25:35',
        '2023-06-16 10:25:35');
COMMIT;

-- ----------------------------
-- Table structure for lcz_page
-- ----------------------------
DROP TABLE IF EXISTS `lcz_page`;
CREATE TABLE `lcz_page`
(
    `id`           int                                                           NOT NULL AUTO_INCREMENT COMMENT '页面id',
    `page_name`    varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '页面名',
    `page_label`   varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '页面标签',
    `page_cover`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '页面封面',
    `gmt_create`   datetime                                                     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` datetime                                                     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='页面';

-- ----------------------------
-- Records of lcz_page
-- ----------------------------
BEGIN;
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (1, '首页', 'home', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:37:08', '2023-06-15 08:23:15');
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (2, '归档', 'archive', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:37:32',
        '2023-06-15 08:25:38');
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (3, '分类', 'category', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:37:45',
        '2023-06-15 08:25:40');
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (4, '标签', 'tag', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:37:54', '2023-06-15 08:25:43');
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (5, '关于', 'about', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:38:10', '2023-06-15 08:25:52');
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (6, '留言', 'message', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:38:25',
        '2023-06-15 08:25:52');
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (7, '个人中心', 'user', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:38:36',
        '2023-06-15 08:25:52');
INSERT INTO `lcz_page` (`id`, `page_name`, `page_label`, `page_cover`, `gmt_create`, `gmt_modified`)
VALUES (8, '文章列表', 'articleList', 'https://s1.ax1x.com/2023/06/15/pCKnaGT.jpg', '2021-10-20 17:38:50',
        '2023-06-15 08:25:52');
COMMIT;

-- ----------------------------
-- Table structure for lcz_resource
-- ----------------------------
DROP TABLE IF EXISTS `lcz_resource`;
CREATE TABLE `lcz_resource`
(
    `id`             int                                                          NOT NULL AUTO_INCREMENT COMMENT '主键',
    `resource_name`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源名',
    `url`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限路径',
    `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '请求方式',
    `parent_id`      int                                                           DEFAULT NULL COMMENT '父权限id',
    `is_anonymous`   tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否匿名访问 0否 1是',
    `gmt_create`     datetime                                                      DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`   datetime                                                      DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='资源\n';

-- ----------------------------
-- Records of lcz_resource
-- ----------------------------
BEGIN;
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (1, '分类模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (2, '博客信息模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (3, '文章模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (4, '日志模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (5, '标签模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (6, '用户模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (7, '留言模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (8, '菜单模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (9, '角色模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (10, '评论模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (11, '资源模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (12, '页面模块', NULL, NULL, NULL, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (13, '查看博客信息', '/', 'GET', 2, 1, '2021-10-20 16:25:35', '2021-10-20 17:26:28');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (14, '查看关于我信息', '/about', 'GET', 2, 1, '2021-10-20 16:25:35', '2021-10-20 17:26:29');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (15, '查看后台信息', '/admin', 'GET', 2, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (16, '修改关于我信息', '/admin/about', 'PUT', 2, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (17, '查看后台文章', '/admin/article', 'GET', 3, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (18, '添加或修改文章', '/admin/article', 'POST', 3, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (19, '恢复或删除文章', '/admin/article', 'PUT', 3, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (20, '物理删除文章', '/admin/article', 'DELETE', 3, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (21, '上传文章图片', '/admin/article/image', 'POST', 3, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (22, '修改文章置顶', '/admin/article/top', 'PUT', 3, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (23, '根据id查看后台文章', '/admin/article/*', 'GET', 3, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (24, '查看后台分类列表', '/admin/category', 'GET', 1, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (25, '添加或修改分类', '/admin/category', 'POST', 1, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (26, '删除分类', '/admin/category', 'DELETE', 1, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (27, '搜索文章分类', '/admin/category/search', 'GET', 1, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (28, '查询后台评论', '/admin/comment', 'GET', 10, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (29, '删除评论', '/admin/comment', 'DELETE', 10, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (30, '审核评论', '/admin/comment/audit', 'PUT', 10, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (31, '上传博客配置图片', '/admin/config/images', 'POST', 2, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (32, '查看操作日志', '/admin/log', 'GET', 4, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (33, '删除操作日志', '/admin/log', 'DELETE', 4, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (34, '查看菜单列表', '/admin/menu', 'GET', 8, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (35, '新增或修改菜单', '/admin/menu', 'POST', 8, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (36, '删除菜单', '/admin/menu/*', 'DELETE', 8, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (37, '查看后台留言列表', '/admin/message', 'GET', 7, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (38, '删除留言', '/admin/message', 'DELETE', 7, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (39, '审核留言', '/admin/messages/audit', 'PUT', 7, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (40, '获取页面列表', '/admin/page', 'GET', 12, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (41, '保存或更新页面', '/admin/page', 'POST', 12, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (42, '删除页面', '/admin/page/*', 'DELETE', 12, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (43, '查看资源列表', '/admin/resource', 'GET', 11, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (44, '新增或修改资源', '/admin/resource', 'POST', 11, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (45, '导入swagger接口', '/admin/resource/import/swagger', 'GET', 11, 0, '2021-10-20 16:25:35',
        '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (46, '删除资源', '/admin/resources/*', 'DELETE', 11, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (47, '查询角色列表', '/admin/role', 'GET', 9, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (48, '保存或更新角色', '/admin/role', 'POST', 9, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (49, '删除角色', '/admin/role', 'DELETE', 9, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (50, '查看角色菜单选项', '/admin/role/menu', 'GET', 8, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (51, '查看角色资源选项', '/admin/role/resource', 'GET', 11, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (52, '查询后台标签列表', '/admin/tag', 'GET', 5, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (53, '添加或修改标签', '/admin/tag', 'POST', 5, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (54, '删除标签', '/admin/tag', 'DELETE', 5, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (55, '搜索文章标签', '/admin/tag/search', 'GET', 5, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (56, '查询后台用户列表', '/admin/user', 'GET', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (57, '获取用户区域分布', '/admin/user/area', 'GET', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (58, '查看当前用户菜单', '/admin/user/menu', 'GET', 8, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (59, '查看在线用户', '/admin/user/online', 'GET', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (60, '下线用户', '/admin/user/online/*', 'DELETE', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (61, '修改管理员密码', '/admin/user/password', 'PUT', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (62, '查询用户角色选项', '/admin/user/role', 'GET', 9, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (63, '修改用户角色', '/admin/user/role', 'PUT', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (64, '修改用户禁用状态', '/admin/user/*', 'PUT', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (65, '获取网站配置', '/admin/website/config', 'GET', 2, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (66, '更新网站配置', '/admin/website/config', 'PUT', 2, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (67, '查看文章归档', '/article/archive', 'GET', 3, 1, '2021-10-20 16:25:35', '2021-10-20 17:27:45');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (68, '点赞文章', '/article/like/*', 'POST', 3, 0, '2021-10-20 16:25:35', '2021-10-20 17:27:37');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (69, '根据条件查询文章', '/article/queryParam', 'GET', 3, 1, '2021-10-20 16:25:35', '2021-10-20 17:27:31');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (70, '搜索文章', '/article/search', 'GET', 3, 1, '2021-10-20 16:25:35', '2021-10-20 17:27:26');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (71, '根据id查看文章', '/article/*', 'GET', 3, 1, '2021-10-20 16:25:35', '2021-10-20 17:27:25');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (72, '查看分类列表', '/category', 'GET', 1, 1, '2021-10-20 16:25:35', '2021-10-20 16:41:49');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (73, '评论点赞', '/comment/like/*', 'POST', 10, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (74, '查询评论下的回复', '/comment/listReply/*', 'GET', 10, 1, '2021-10-20 16:25:35', '2021-10-20 17:29:44');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (75, '添加评论', '/comment/saveComment', 'POST', 10, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (76, '查询评论', '/comment/*', 'GET', 10, 1, '2021-10-20 16:25:35', '2021-10-20 17:29:45');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (77, '查看首页文章', '/home', 'GET', 3, 1, '2021-10-20 16:25:35', '2021-10-20 17:27:21');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (78, '查看留言列表', '/message', 'GET', 7, 1, '2021-10-20 16:25:35', '2021-10-20 17:29:15');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (79, '添加留言', '/message', 'POST', 7, 1, '2021-10-20 16:25:35', '2021-10-20 17:29:16');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (80, '上传访客信息', '/report', 'POST', 2, 1, '2021-10-20 16:25:35', '2021-10-20 17:26:44');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (81, '查询标签列表', '/tag', 'GET', 5, 1, '2021-10-20 16:25:35', '2021-10-20 17:28:14');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (82, '更新用户头像', '/user/avatar', 'POST', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (83, '发送邮箱验证码', '/user/code', 'GET', 6, 1, '2021-10-20 16:25:35', '2021-10-20 17:28:41');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (84, '修改密码', '/user/forget', 'PUT', 6, 1, '2021-10-20 16:25:35', '2021-10-20 17:28:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (85, '用户注册', '/user/register', 'POST', 6, 1, '2021-10-20 16:25:35', '2021-10-20 17:28:33');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (86, '绑定用户邮箱', '/user/updateEmail', 'PUT', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
INSERT INTO `lcz_resource` (`id`, `resource_name`, `url`, `request_method`, `parent_id`, `is_anonymous`, `gmt_create`,
                            `gmt_modified`)
VALUES (87, '更新用户信息', '/user/updateUserInfo', 'PUT', 6, 0, '2021-10-20 16:25:35', '2021-10-20 16:25:35');
COMMIT;

-- ----------------------------
-- Table structure for lcz_role
-- ----------------------------
DROP TABLE IF EXISTS `lcz_role`;
CREATE TABLE `lcz_role`
(
    `id`           int NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `role_name`    varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色名',
    `role_label`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色描述',
    `is_disable`   tinyint(1) DEFAULT '0' COMMENT '是否禁用  0否 1是',
    `gmt_create`   datetime                                                     DEFAULT CURRENT_TIMESTAMP COMMENT '发表时间',
    `gmt_modified` datetime                                                     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色\n';

-- ----------------------------
-- Records of lcz_role
-- ----------------------------
BEGIN;
INSERT INTO `lcz_role` (`id`, `role_name`, `role_label`, `is_disable`, `gmt_create`, `gmt_modified`)
VALUES (1, '管理员', 'admin', 0, '2021-10-10 14:12:41', '2021-10-20 16:55:42');
INSERT INTO `lcz_role` (`id`, `role_name`, `role_label`, `is_disable`, `gmt_create`, `gmt_modified`)
VALUES (2, '用户', 'user', 0, '2021-10-10 14:12:41', '2021-10-20 17:20:50');
INSERT INTO `lcz_role` (`id`, `role_name`, `role_label`, `is_disable`, `gmt_create`, `gmt_modified`)
VALUES (3, '测试', 'test', 0, '2021-10-10 14:12:41', '2021-10-20 17:25:03');
COMMIT;

-- ----------------------------
-- Table structure for lcz_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `lcz_role_menu`;
CREATE TABLE `lcz_role_menu`
(
    `id`           int NOT NULL AUTO_INCREMENT COMMENT '主键',
    `role_id`      int      DEFAULT NULL COMMENT '角色id',
    `menu_id`      int      DEFAULT NULL COMMENT '菜单id',
    `gmt_create`   datetime DEFAULT CURRENT_TIMESTAMP COMMENT '发表时间',
    `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色菜单\n';

-- ----------------------------
-- Records of lcz_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (115, 3, 1, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (116, 3, 2, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (117, 3, 6, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (118, 3, 7, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (119, 3, 8, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (120, 3, 9, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (121, 3, 10, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (122, 3, 3, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (123, 3, 11, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (124, 3, 12, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (125, 3, 22, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (126, 3, 13, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (127, 3, 21, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (128, 3, 28, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (129, 3, 14, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (130, 3, 15, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (131, 3, 16, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (132, 3, 4, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (133, 3, 29, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (134, 3, 26, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (135, 3, 18, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (136, 3, 24, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (137, 3, 25, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (138, 3, 27, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (139, 3, 19, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (140, 3, 20, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (141, 3, 5, '2021-10-20 16:55:38', '2021-10-20 16:55:38');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (142, 1, 1, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (143, 1, 2, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (144, 1, 6, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (145, 1, 7, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (146, 1, 8, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (147, 1, 9, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (148, 1, 10, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (149, 1, 3, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (150, 1, 11, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (151, 1, 12, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (152, 1, 22, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (153, 1, 13, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (154, 1, 21, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (155, 1, 28, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (156, 1, 14, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (157, 1, 15, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (158, 1, 16, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (159, 1, 4, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (160, 1, 29, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (161, 1, 26, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (162, 1, 18, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (163, 1, 24, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (164, 1, 25, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (165, 1, 27, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (166, 1, 19, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (167, 1, 20, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
INSERT INTO `lcz_role_menu` (`id`, `role_id`, `menu_id`, `gmt_create`, `gmt_modified`)
VALUES (168, 1, 5, '2021-10-20 16:55:42', '2021-10-20 16:55:42');
COMMIT;

-- ----------------------------
-- Table structure for lcz_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `lcz_role_resource`;
CREATE TABLE `lcz_role_resource`
(
    `id`           int NOT NULL AUTO_INCREMENT,
    `role_id`      int      DEFAULT NULL COMMENT '角色id',
    `resource_id`  int      DEFAULT NULL COMMENT '权限id',
    `gmt_create`   datetime DEFAULT CURRENT_TIMESTAMP COMMENT '发表时间',
    `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=286 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色资源\n';

-- ----------------------------
-- Records of lcz_role_resource
-- ----------------------------
BEGIN;
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (128, 1, 1, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (129, 1, 2, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (130, 1, 3, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (131, 1, 4, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (132, 1, 5, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (133, 1, 6, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (134, 1, 7, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (135, 1, 8, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (136, 1, 9, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (137, 1, 10, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (138, 1, 11, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (139, 1, 12, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (140, 1, 13, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (141, 1, 14, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (142, 1, 15, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (143, 1, 16, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (144, 1, 17, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (145, 1, 18, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (146, 1, 19, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (147, 1, 20, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (148, 1, 21, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (149, 1, 22, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (150, 1, 23, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (151, 1, 24, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (152, 1, 25, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (153, 1, 26, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (154, 1, 27, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (155, 1, 28, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (156, 1, 29, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (157, 1, 30, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (158, 1, 31, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (159, 1, 32, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (160, 1, 33, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (161, 1, 34, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (162, 1, 35, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (163, 1, 36, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (164, 1, 37, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (165, 1, 38, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (166, 1, 39, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (167, 1, 40, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (168, 1, 41, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (169, 1, 42, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (170, 1, 43, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (171, 1, 44, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (172, 1, 45, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (173, 1, 46, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (174, 1, 47, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (175, 1, 48, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (176, 1, 49, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (177, 1, 50, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (178, 1, 51, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (179, 1, 52, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (180, 1, 53, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (181, 1, 54, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (182, 1, 55, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (183, 1, 56, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (184, 1, 57, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (185, 1, 58, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (186, 1, 59, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (187, 1, 60, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (188, 1, 61, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (189, 1, 62, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (190, 1, 63, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (191, 1, 64, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (192, 1, 65, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (193, 1, 66, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (194, 1, 67, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (195, 1, 68, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (196, 1, 69, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (197, 1, 70, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (198, 1, 71, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (199, 1, 72, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (200, 1, 73, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (201, 1, 74, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (202, 1, 75, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (203, 1, 76, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (204, 1, 77, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (205, 1, 78, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (206, 1, 79, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (207, 1, 80, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (208, 1, 81, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (209, 1, 82, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (210, 1, 83, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (211, 1, 84, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (212, 1, 85, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (213, 1, 86, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (214, 1, 87, '2021-10-20 16:26:17', '2021-10-20 16:26:17');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (255, 2, 68, '2021-10-20 17:20:50', '2021-10-20 17:20:50');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (256, 2, 82, '2021-10-20 17:20:50', '2021-10-20 17:20:50');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (257, 2, 86, '2021-10-20 17:20:50', '2021-10-20 17:20:50');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (258, 2, 87, '2021-10-20 17:20:50', '2021-10-20 17:20:50');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (259, 2, 73, '2021-10-20 17:20:50', '2021-10-20 17:20:50');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (260, 2, 75, '2021-10-20 17:20:50', '2021-10-20 17:20:50');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (261, 3, 24, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (262, 3, 27, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (263, 3, 15, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (264, 3, 65, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (265, 3, 17, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (266, 3, 23, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (267, 3, 68, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (268, 3, 32, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (269, 3, 52, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (270, 3, 55, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (271, 3, 56, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (272, 3, 57, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (273, 3, 59, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (274, 3, 37, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (275, 3, 34, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (276, 3, 50, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (277, 3, 58, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (278, 3, 47, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (279, 3, 62, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (280, 3, 28, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (281, 3, 73, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (282, 3, 75, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (283, 3, 43, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (284, 3, 51, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
INSERT INTO `lcz_role_resource` (`id`, `role_id`, `resource_id`, `gmt_create`, `gmt_modified`)
VALUES (285, 3, 40, '2021-10-20 17:25:03', '2021-10-20 17:25:03');
COMMIT;

-- ----------------------------
-- Table structure for lcz_tag
-- ----------------------------
DROP TABLE IF EXISTS `lcz_tag`;
CREATE TABLE `lcz_tag`
(
    `id`           int                                                          NOT NULL AUTO_INCREMENT,
    `tag_name`     varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签名',
    `gmt_create`   datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='标签\n';

-- ----------------------------
-- Records of lcz_tag
-- ----------------------------
BEGIN;
INSERT INTO `lcz_tag` (`id`, `tag_name`, `gmt_create`, `gmt_modified`)
VALUES (1, '测试标签', '2021-10-11 16:49:06', '2021-10-11 16:49:06');
COMMIT;

-- ----------------------------
-- Table structure for lcz_unique_view
-- ----------------------------
DROP TABLE IF EXISTS `lcz_unique_view`;
CREATE TABLE `lcz_unique_view`
(
    `id`           int      NOT NULL AUTO_INCREMENT,
    `view_count`   int      NOT NULL COMMENT '访问量',
    `gmt_create`   datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` datetime          DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='访问量\n';

-- ----------------------------
-- Records of lcz_unique_view
-- ----------------------------
BEGIN;
INSERT INTO `lcz_unique_view` (`id`, `view_count`, `gmt_create`, `gmt_modified`)
VALUES (1, 2, '2021-10-23 00:00:00', '2021-10-23 00:00:00');
INSERT INTO `lcz_unique_view` (`id`, `view_count`, `gmt_create`, `gmt_modified`)
VALUES (2, 6, '2021-10-24 00:00:00', '2021-10-24 00:00:00');
INSERT INTO `lcz_unique_view` (`id`, `view_count`, `gmt_create`, `gmt_modified`)
VALUES (3, 3, '2021-10-25 00:00:00', '2021-10-25 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for lcz_user
-- ----------------------------
DROP TABLE IF EXISTS `lcz_user`;
CREATE TABLE `lcz_user`
(
    `id`              int NOT NULL AUTO_INCREMENT,
    `email`           varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '邮箱，用户名',
    `password`        varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '密码',
    `avatar`          varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像',
    `nickname`        varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '昵称',
    `intro`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '用户简介',
    `web_site`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '个人网站',
    `ip_addr`         varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT '用户登录ip',
    `ip_source`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   DEFAULT NULL COMMENT 'ip来源',
    `is_disable`      tinyint(1) DEFAULT '0' COMMENT '是否禁用 0正常 1禁用',
    `last_login_time` datetime                                                       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上次登录时间',
    `gmt_create`      datetime                                                       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`    datetime                                                       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_email` (`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户\n';

-- ----------------------------
-- Records of lcz_user
-- ----------------------------
BEGIN;
INSERT INTO `lcz_user` (`id`, `email`, `password`, `avatar`, `nickname`, `intro`, `web_site`, `ip_addr`, `ip_source`,
                        `is_disable`, `last_login_time`, `gmt_create`, `gmt_modified`)
VALUES (1, 'admin@qq.com', '$2a$10$TxzLJwN4fcf0ZUO7ma5q9.GVAB.DXY62QtOqSb2efabaogwH8DZGS',
        'https://s2.loli.net/2023/06/16/CLvuKcQ7e9aV5Rz.png', '管理员', '管理员账号', NULL, '127.0.0.1', '', 0,
        '2023-06-16 10:25:20', '2021-10-11 15:01:14', '2023-06-16 10:25:21');
INSERT INTO `lcz_user` (`id`, `email`, `password`, `avatar`, `nickname`, `intro`, `web_site`, `ip_addr`, `ip_source`,
                        `is_disable`, `last_login_time`, `gmt_create`, `gmt_modified`)
VALUES (2, 'test@qq.com', '$2a$10$TxzLJwN4fcf0ZUO7ma5q9.GVAB.DXY62QtOqSb2efabaogwH8DZGS',
        'https://s2.loli.net/2023/06/16/CLvuKcQ7e9aV5Rz.png', '测试账号', '仅用作测试', NULL, '127.0.0.1', '', 0,
        '2023-06-16 02:20:14', '2021-10-11 15:01:14', '2023-06-16 02:20:14');
COMMIT;

-- ----------------------------
-- Table structure for lcz_user_role
-- ----------------------------
DROP TABLE IF EXISTS `lcz_user_role`;
CREATE TABLE `lcz_user_role`
(
    `id`           int NOT NULL AUTO_INCREMENT,
    `user_id`      int      DEFAULT NULL COMMENT '用户id',
    `role_id`      int      DEFAULT NULL COMMENT '角色id',
    `gmt_create`   datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户角色\n';

-- ----------------------------
-- Records of lcz_user_role
-- ----------------------------
BEGIN;
INSERT INTO `lcz_user_role` (`id`, `user_id`, `role_id`, `gmt_create`, `gmt_modified`)
VALUES (1, 1, 1, '2021-10-11 15:01:13', '2021-10-14 15:02:22');
INSERT INTO `lcz_user_role` (`id`, `user_id`, `role_id`, `gmt_create`, `gmt_modified`)
VALUES (2, 2, 3, '2021-10-15 17:54:24', '2021-10-15 17:54:24');
INSERT INTO `lcz_user_role` (`id`, `user_id`, `role_id`, `gmt_create`, `gmt_modified`)
VALUES (3, 3, 2, '2023-06-16 09:48:11', '2023-06-16 09:48:11');
COMMIT;

-- ----------------------------
-- Table structure for lcz_website_config
-- ----------------------------
DROP TABLE IF EXISTS `lcz_website_config`;
CREATE TABLE `lcz_website_config`
(
    `id`           int NOT NULL AUTO_INCREMENT,
    `config`       varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配置信息',
    `gmt_create`   datetime                                                       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` datetime                                                       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='网站配置\n';

-- ----------------------------
-- Records of lcz_website_config
-- ----------------------------
BEGIN;
INSERT INTO `lcz_website_config` (`id`, `config`, `gmt_create`, `gmt_modified`)
VALUES (1,
        '{\"alipayQRCode\":\"http://rw9u4bo2x.hn-bkt.clouddn.com/config/1d0342b8-c217-41a8-9cdb-e6fbef49d97f.png\",\"gitee\":\"https://gitee.com/lcz2000\",\"github\":\"https://gitee.com/lcz2000\",\"isCommentAudit\":1,\"isEmailNotice\":1,\"isMessageAudit\":1,\"isReward\":1,\"socialUrlList\":[\"gitee\"],\"touristAvatar\":\"http://rw9u4bo2x.hn-bkt.clouddn.com/config/991b4b33-9125-45a8-a149-d68e94587406.png\",\"weChatQRCode\":\"http://rw9u4bo2x.hn-bkt.clouddn.com/config/b5f61885-4f10-4b9d-b04f-3e08ee4b0181.png\",\"websiteAuthor\":\"lcz\",\"websiteAvatar\":\"http://rw9u4bo2x.hn-bkt.clouddn.com/config/4a699535-e8e4-4631-8efb-79f2fa7a9bf5.png\",\"websiteCreateTime\":\"2021-10-01\",\"websiteIntro\":\"秋天的风也能遇见春天的花\",\"websiteName\":\"lcz的个人博客\",\"websiteNotice\":\"网站刚刚上线，有bug很正常，多多见谅\",\"websiteRecordNo\":\"备案号\"}',
        '2021-10-19 20:04:13', '2023-06-16 09:52:11');
COMMIT;

SET
FOREIGN_KEY_CHECKS = 1;
